import matplotlib.pyplot as plt
import pandas as pd
df = pd.read_excel('旅游网站精华游记数据_预处理.xlsx')
plt.rcParams['font.sans-serif'] = 'SimHei'
df_month = df.groupby('月份').size()
plt.figure(figsize=(10,5))
x=df_month.index
plt.plot(x,df_month,color=(0.894,0,0.498))
plt.xticks(range(1,13))
plt.xlabel('月份')
plt.ylabel('旅游次数')
plt.title('每月旅客旅游次数折线图')
for a,b in zip(x,df_month):
    plt.text(a,b,'%d'%b,ha='center')
plt.show()